using System;
using System.Collections.Generic;
using System.Text;

namespace FetCo.Data
{
    public static class Condition
    {

        #region CompareType
        /*And*/
        public const string AND = " AND ";
        /*OR*/
        public const string OR = " OR ";

        /** Comparison type. */
        public const string EQUAL = "=";

        /** Comparison type. */
        public const string NOT_EQUAL = "<>";

        /** Comparison type. */
        public const string ALT_NOT_EQUAL = "!=";

        /** Comparison type. */
        public const string GREATER_THAN = ">";

        /** Comparison type. */
        public const string LESS_THAN = "<";

        /** Comparison type. */
        public const string GREATER_EQUAL = ">=";

        /** Comparison type. */
        public const string LESS_EQUAL = "<=";

        /** Comparison type. */
        public const string LIKE = " LIKE ";

        /** Comparison type. */
        public const string NOT_LIKE = " NOT LIKE ";

        /** PostgreSQL comparison type */
     //   public const string ILIKE = " ILIKE ";

        /** PostgreSQL comparison type */
     //   public const string NOT_ILIKE = " NOT ILIKE ";

        /** Comparison type. */
     //   public const string CUSTOM = "CUSTOM";

        /** Comparison type for update */
        public const string CUSTOM_EQUAL = "CUSTOM_EQUAL";

        /** Comparison type. */
   //     public const string DISTINCT = "DISTINCT ";

        /** Comparison type. */
  //      public const string IN = " IN ";

        /** Comparison type. */
  //      public const string NOT_IN = " NOT IN ";

        /** Comparison type. */
   //     public const string ALL = "ALL ";

        /** Comparison type. */
        public const string JOIN = "JOIN";

        /** Binary math operator: AND */
        public const string BINARY_AND = "&";

        /** Binary math operator: OR */
        public const string BINARY_OR = "|";
        
        /** "IS NULL" null comparison */
        public const string ISNULL = " IS NULL ";

        /** "IS NOT NULL" null comparison */
        public const string ISNOTNULL = " IS NOT NULL ";

        /** "CURRENT_DATE" ANSI SQL function */
    //    public const string CURRENT_DATE = "CURRENT_DATE";

        /** "CURRENT_TIME" ANSI SQL function */
        public const string CURRENT_TIME = "CURRENT_TIME";

        /** "CURRENT_TIMESTAMP" ANSI SQL function */
        public const string CURRENT_TIMESTAMP = "CURRENT_TIMESTAMP";

        /** "LEFT JOIN" SQL statement */
        public const string LEFT_JOIN = "LEFT JOIN";

        /** "RIGHT JOIN" SQL statement */
        public const string RIGHT_JOIN = "RIGHT JOIN";

        /** "INNER JOIN" SQL statement */
        public const string INNER_JOIN = "INNER JOIN";
        #endregion

    }
}
